How can I achieve the expected result using a recursive query in Oracle SQL

join shbcf.ru